Overview
Brought to you by YData
Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 104651 |
| Missing cells | 16211 |
| Missing cells (%) | 0.6% |
| Duplicate rows | 2565 |
| Duplicate rows (%) | 2.5% |
| Total size in memory | 71.2 MiB |
| Average record size in memory | 712.9 B |
Variable types
| Numeric | 13 |
|---|---|
| Text | 3 |
| Categorical | 6 |
| Boolean | 1 |
| DateTime | 1 |
country has constant value "UNITED STATES" | Constant |
country code has constant value "US" | Constant |
| Dataset has 2565 (2.5%) duplicate rows | Duplicates |
long is highly overall correlated with neighbourhood group | High correlation |
neighbourhood group is highly overall correlated with long | High correlation |
number of reviews is highly overall correlated with reviews per month | High correlation |
price_clean is highly overall correlated with service fee_cleaned | High correlation |
reviews per month is highly overall correlated with number of reviews | High correlation |
service fee_cleaned is highly overall correlated with price_clean | High correlation |
last review_date has 16206 (15.5%) missing values | Missing |
number of reviews has 16045 (15.3%) zeros | Zeros |
availability 365 has 24007 (22.9%) zeros | Zeros |
Reproduction
| Analysis started | 2025-10-21 17:26:14.628852 |
|---|---|
| Analysis finished | 2025-10-21 17:26:58.405362 |
| Duration | 43.78 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
id
Real number (ℝ)
| Distinct | 102058 |
|---|---|
| Distinct (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29144003 |
| Minimum | 1001254 |
|---|---|
| Maximum | 57367417 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | 1001254 |
|---|---|
| 5-th percentile | 3834911 |
| Q1 | 15088024 |
| median | 29134946 |
| Q3 | 43188496 |
| 95-th percentile | 54528319 |
| Maximum | 57367417 |
| Range | 56366163 |
| Interquartile range (IQR) | 28100472 |
Descriptive statistics
| Standard deviation | 16253954 |
|---|---|
| Coefficient of variation (CV) | 0.55771179 |
| Kurtosis | -1.1974283 |
| Mean | 29144003 |
| Median Absolute Deviation (MAD) | 14051064 |
| Skewness | 0.0030807631 |
| Sum | 3.049949 × 1012 |
| Variance | 2.6419102 × 1014 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20387618 | 4 | < 0.1% |
| 20308087 | 3 | < 0.1% |
| 20340121 | 3 | < 0.1% |
| 35589676 | 3 | < 0.1% |
| 35523400 | 3 | < 0.1% |
| 20341777 | 3 | < 0.1% |
| 35588019 | 3 | < 0.1% |
| 20346748 | 3 | < 0.1% |
| 35541626 | 3 | < 0.1% |
| 20316372 | 3 | < 0.1% |
| Other values (102048) | 104620 |
| Value | Count | Frequency (%) |
| 1001254 | 1 | |
| 1002102 | 1 | |
| 1002403 | 1 | |
| 1002755 | 1 | |
| 1003689 | 1 | |
| 1004098 | 1 | |
| 1004650 | 1 | |
| 1005202 | 1 | |
| 1005754 | 1 | |
| 1006307 | 1 |
| Value | Count | Frequency (%) |
| 57367417 | 1 | |
| 57366865 | 1 | |
| 57366313 | 1 | |
| 57365760 | 1 | |
| 57365208 | 1 | |
| 57364656 | 1 | |
| 57364103 | 1 | |
| 57363551 | 1 | |
| 57362999 | 1 | |
| 57362446 | 1 |
NAME
Text
| Distinct | 60662 |
|---|---|
| Distinct (%) | 58.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
Length
| Max length | 248 |
|---|---|
| Median length | 147 |
| Mean length | 37.522527 |
| Min length | 1 |
Unique
| Unique | 31282 ? |
|---|---|
| Unique (%) | 29.9% |
Sample
| 1st row | CLASSIC ARTIST LOFT |
|---|---|
| 2nd row | ÉTAGE AU SEIN D’UN DUPLEX À BROOKLYN |
| 3rd row | AMAZING VIEW IN ULTRA LUXURY MIDTOWN APARTMENT! |
| 4th row | HARLEM HOME AWAY FROM HOME! |
| 5th row | COZY LOFT IN FLUSHING |
| Value | Count | Frequency (%) |
| in | 35567 | 5.5% |
| room | 21700 | 3.3% |
| 18290 | 2.8% | |
| bedroom | 16434 | 2.5% |
| private | 15851 | 2.4% |
| apartment | 14395 | 2.2% |
| cozy | 10761 | 1.7% |
| apt | 9533 | 1.5% |
| studio | 8856 | 1.4% |
| brooklyn | 8760 | 1.3% |
| Other values (16029) | 489507 |
Most occurring characters
| Value | Count | Frequency (%) |
| 548352 | ||
| E | 304854 | 7.8% |
| O | 287448 | 7.3% |
| A | 267062 | 6.8% |
| T | 255331 | 6.5% |
| R | 251416 | 6.4% |
| N | 230792 | 5.9% |
| I | 219715 | 5.6% |
| S | 160398 | 4.1% |
| L | 141711 | 3.6% |
| Other values (939) | 1259691 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3926770 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 548352 | ||
| E | 304854 | 7.8% |
| O | 287448 | 7.3% |
| A | 267062 | 6.8% |
| T | 255331 | 6.5% |
| R | 251416 | 6.4% |
| N | 230792 | 5.9% |
| I | 219715 | 5.6% |
| S | 160398 | 4.1% |
| L | 141711 | 3.6% |
| Other values (939) | 1259691 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3926770 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 548352 | ||
| E | 304854 | 7.8% |
| O | 287448 | 7.3% |
| A | 267062 | 6.8% |
| T | 255331 | 6.5% |
| R | 251416 | 6.4% |
| N | 230792 | 5.9% |
| I | 219715 | 5.6% |
| S | 160398 | 4.1% |
| L | 141711 | 3.6% |
| Other values (939) | 1259691 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3926770 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 548352 | ||
| E | 304854 | 7.8% |
| O | 287448 | 7.3% |
| A | 267062 | 6.8% |
| T | 255331 | 6.5% |
| R | 251416 | 6.4% |
| N | 230792 | 5.9% |
| I | 219715 | 5.6% |
| S | 160398 | 4.1% |
| L | 141711 | 3.6% |
| Other values (939) | 1259691 |
host id
Real number (ℝ)
| Distinct | 102057 |
|---|---|
| Distinct (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.9259364 × 1010 |
| Minimum | 1.2360052 × 108 |
|---|---|
| Maximum | 9.8763129 × 1010 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | 1.2360052 × 108 |
|---|---|
| 5-th percentile | 4.9222327 × 109 |
| Q1 | 2.4609577 × 1010 |
| median | 4.9106518 × 1010 |
| Q3 | 7.399603 × 1010 |
| 95-th percentile | 9.3820735 × 1010 |
| Maximum | 9.8763129 × 1010 |
| Range | 9.8639529 × 1010 |
| Interquartile range (IQR) | 4.9386452 × 1010 |
Descriptive statistics
| Standard deviation | 2.8532715 × 1010 |
|---|---|
| Coefficient of variation (CV) | 0.57923434 |
| Kurtosis | -1.201732 |
| Mean | 4.9259364 × 1010 |
| Median Absolute Deviation (MAD) | 2.4704505 × 1010 |
| Skewness | 0.0071010287 |
| Sum | 5.1550417 × 1015 |
| Variance | 8.1411582 × 1020 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1165490779 | 4 | < 0.1% |
| 9.752824846 × 1010 | 3 | < 0.1% |
| 4.072550887 × 1010 | 3 | < 0.1% |
| 2.103552879 × 1010 | 3 | < 0.1% |
| 9.145632944 × 1010 | 3 | < 0.1% |
| 8.946153186 × 1010 | 3 | < 0.1% |
| 5.759150292 × 1010 | 3 | < 0.1% |
| 1.212779805 × 1010 | 3 | < 0.1% |
| 6268316412 | 3 | < 0.1% |
| 4.6677963 × 1010 | 3 | < 0.1% |
| Other values (102047) | 104620 |
| Value | Count | Frequency (%) |
| 123600518 | 1 | |
| 124039648 | 1 | |
| 124472619 | 1 | |
| 129756565 | 1 | |
| 130349612 | 1 | |
| 130593431 | 1 | |
| 131602089 | 1 | |
| 132238305 | 1 | |
| 133264740 | 1 | |
| 134452120 | 1 |
| Value | Count | Frequency (%) |
| 9.876312902 × 1010 | 1 | |
| 9.876268323 × 1010 | 1 | |
| 9.876266181 × 1010 | 1 | |
| 9.876096863 × 1010 | 1 | |
| 9.875813627 × 1010 | 1 | |
| 9.875797561 × 1010 | 1 | |
| 9.875795011 × 1010 | 1 | |
| 9.875764603 × 1010 | 1 | |
| 9.87574594 × 1010 | 1 | |
| 9.875733136 × 1010 | 1 |
host_identity_verified
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
| UNCONFIRMED | |
|---|---|
| VERIFIED |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.504859 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | VERIFIED |
|---|---|
| 2nd row | UNCONFIRMED |
| 3rd row | VERIFIED |
| 4th row | VERIFIED |
| 5th row | VERIFIED |
Common Values
| Value | Count | Frequency (%) |
| UNCONFIRMED | 52495 | |
| VERIFIED | 52156 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| unconfirmed | 52495 | |
| verified | 52156 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 156807 | |
| E | 156807 | |
| N | 104990 | |
| D | 104651 | |
| F | 104651 | |
| R | 104651 | |
| U | 52495 | 5.3% |
| C | 52495 | 5.3% |
| O | 52495 | 5.3% |
| M | 52495 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 994693 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| I | 156807 | |
| E | 156807 | |
| N | 104990 | |
| D | 104651 | |
| F | 104651 | |
| R | 104651 | |
| U | 52495 | 5.3% |
| C | 52495 | 5.3% |
| O | 52495 | 5.3% |
| M | 52495 | 5.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 994693 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| I | 156807 | |
| E | 156807 | |
| N | 104990 | |
| D | 104651 | |
| F | 104651 | |
| R | 104651 | |
| U | 52495 | 5.3% |
| C | 52495 | 5.3% |
| O | 52495 | 5.3% |
| M | 52495 | 5.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 994693 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| I | 156807 | |
| E | 156807 | |
| N | 104990 | |
| D | 104651 | |
| F | 104651 | |
| R | 104651 | |
| U | 52495 | 5.3% |
| C | 52495 | 5.3% |
| O | 52495 | 5.3% |
| M | 52495 | 5.3% |
host name
Text
| Distinct | 13155 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Memory size | 5.5 MiB |
Length
| Max length | 35 |
|---|---|
| Median length | 32 |
| Mean length | 6.1777325 |
| Min length | 1 |
Unique
| Unique | 3839 ? |
|---|---|
| Unique (%) | 3.7% |
Sample
| 1st row | JOSH |
|---|---|
| 2nd row | SOPHIE & GRÉGOIRE |
| 3rd row | MAY |
| 4th row | ARIELLE |
| 5th row | ERJON |
| Value | Count | Frequency (%) |
| 2379 | 2.0% | |
| michael | 1419 | 1.2% |
| and | 1414 | 1.2% |
| david | 866 | 0.7% |
| sonder | 755 | 0.6% |
| alex | 687 | 0.6% |
| john | 671 | 0.6% |
| nyc | 563 | 0.5% |
| laura | 548 | 0.5% |
| daniel | 525 | 0.4% |
| Other values (11709) | 107616 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 94874 | |
| E | 67156 | 10.4% |
| N | 56217 | 8.7% |
| I | 54527 | 8.4% |
| R | 43975 | 6.8% |
| L | 39460 | 6.1% |
| S | 30176 | 4.7% |
| O | 28947 | 4.5% |
| T | 24614 | 3.8% |
| M | 23062 | 3.6% |
| Other values (170) | 183467 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 646475 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 94874 | |
| E | 67156 | 10.4% |
| N | 56217 | 8.7% |
| I | 54527 | 8.4% |
| R | 43975 | 6.8% |
| L | 39460 | 6.1% |
| S | 30176 | 4.7% |
| O | 28947 | 4.5% |
| T | 24614 | 3.8% |
| M | 23062 | 3.6% |
| Other values (170) | 183467 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 646475 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 94874 | |
| E | 67156 | 10.4% |
| N | 56217 | 8.7% |
| I | 54527 | 8.4% |
| R | 43975 | 6.8% |
| L | 39460 | 6.1% |
| S | 30176 | 4.7% |
| O | 28947 | 4.5% |
| T | 24614 | 3.8% |
| M | 23062 | 3.6% |
| Other values (170) | 183467 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 646475 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 94874 | |
| E | 67156 | 10.4% |
| N | 56217 | 8.7% |
| I | 54527 | 8.4% |
| R | 43975 | 6.8% |
| L | 39460 | 6.1% |
| S | 30176 | 4.7% |
| O | 28947 | 4.5% |
| T | 24614 | 3.8% |
| M | 23062 | 3.6% |
| Other values (170) | 183467 |
neighbourhood group
Categorical
High correlation
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.7 MiB |
| MANHATTAN | |
|---|---|
| BROOKLYN | |
| QUEENS | |
| BRONX | 2774 |
| STATEN ISLAND | 971 |
| Other values (2) | 2 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 8.1355458 |
| Min length | 5 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BROOKLYN |
|---|---|
| 2nd row | BROOKLYN |
| 3rd row | MANHATTAN |
| 4th row | MANHATTAN |
| 5th row | QUEENS |
Common Values
| Value | Count | Frequency (%) |
| MANHATTAN | 44701 | |
| BROOKLYN | 42679 | |
| QUEENS | 13524 | 12.9% |
| BRONX | 2774 | 2.7% |
| STATEN ISLAND | 971 | 0.9% |
| BROOKLN | 1 | < 0.1% |
| MANHATAN | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| manhattan | 44701 | |
| brooklyn | 42679 | |
| queens | 13524 | 12.8% |
| bronx | 2774 | 2.6% |
| staten | 971 | 0.9% |
| island | 971 | 0.9% |
| brookln | 1 | < 0.1% |
| manhatan | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 150324 | |
| A | 136048 | |
| T | 91345 | |
| O | 88134 | |
| R | 45454 | 5.3% |
| B | 45454 | 5.3% |
| M | 44702 | 5.3% |
| H | 44702 | 5.3% |
| L | 43651 | 5.1% |
| K | 42680 | 5.0% |
| Other values (9) | 118899 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 851393 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 150324 | |
| A | 136048 | |
| T | 91345 | |
| O | 88134 | |
| R | 45454 | 5.3% |
| B | 45454 | 5.3% |
| M | 44702 | 5.3% |
| H | 44702 | 5.3% |
| L | 43651 | 5.1% |
| K | 42680 | 5.0% |
| Other values (9) | 118899 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 851393 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 150324 | |
| A | 136048 | |
| T | 91345 | |
| O | 88134 | |
| R | 45454 | 5.3% |
| B | 45454 | 5.3% |
| M | 44702 | 5.3% |
| H | 44702 | 5.3% |
| L | 43651 | 5.1% |
| K | 42680 | 5.0% |
| Other values (9) | 118899 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 851393 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 150324 | |
| A | 136048 | |
| T | 91345 | |
| O | 88134 | |
| R | 45454 | 5.3% |
| B | 45454 | 5.3% |
| M | 44702 | 5.3% |
| H | 44702 | 5.3% |
| L | 43651 | 5.1% |
| K | 42680 | 5.0% |
| Other values (9) | 118899 |
neighbourhood
Text
| Distinct | 224 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.1 MiB |
Length
| Max length | 26 |
|---|---|
| Median length | 18 |
| Mean length | 11.870828 |
| Min length | 4 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | COLUMBIA ST |
|---|---|
| 2nd row | CLINTON HILL |
| 3rd row | HELL'S KITCHEN |
| 4th row | HARLEM |
| 5th row | FLUSHING |
| Value | Count | Frequency (%) |
| east | 14061 | 8.3% |
| side | 9678 | 5.7% |
| bedford-stuyvesant | 8110 | 4.8% |
| harlem | 7966 | 4.7% |
| williamsburg | 7918 | 4.7% |
| upper | 7694 | 4.6% |
| heights | 7475 | 4.4% |
| village | 6181 | 3.7% |
| west | 5521 | 3.3% |
| bushwick | 5089 | 3.0% |
| Other values (236) | 89097 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 128938 | 10.4% |
| S | 109449 | 8.8% |
| I | 90734 | 7.3% |
| T | 84327 | 6.8% |
| A | 83853 | 6.7% |
| L | 76962 | 6.2% |
| R | 74551 | 6.0% |
| 64139 | 5.2% | |
| N | 57924 | 4.7% |
| H | 56880 | 4.6% |
| Other values (21) | 414537 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1242294 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 128938 | 10.4% |
| S | 109449 | 8.8% |
| I | 90734 | 7.3% |
| T | 84327 | 6.8% |
| A | 83853 | 6.7% |
| L | 76962 | 6.2% |
| R | 74551 | 6.0% |
| 64139 | 5.2% | |
| N | 57924 | 4.7% |
| H | 56880 | 4.6% |
| Other values (21) | 414537 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1242294 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 128938 | 10.4% |
| S | 109449 | 8.8% |
| I | 90734 | 7.3% |
| T | 84327 | 6.8% |
| A | 83853 | 6.7% |
| L | 76962 | 6.2% |
| R | 74551 | 6.0% |
| 64139 | 5.2% | |
| N | 57924 | 4.7% |
| H | 56880 | 4.6% |
| Other values (21) | 414537 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1242294 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 128938 | 10.4% |
| S | 109449 | 8.8% |
| I | 90734 | 7.3% |
| T | 84327 | 6.8% |
| A | 83853 | 6.7% |
| L | 76962 | 6.2% |
| R | 74551 | 6.0% |
| 64139 | 5.2% | |
| N | 57924 | 4.7% |
| H | 56880 | 4.6% |
| Other values (21) | 414537 |
lat
Real number (ℝ)
| Distinct | 21992 |
|---|---|
| Distinct (%) | 21.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.728072 |
| Minimum | 40.49979 |
|---|---|
| Maximum | 40.91697 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | 40.49979 |
|---|---|
| 5-th percentile | 40.64318 |
| Q1 | 40.68874 |
| median | 40.72228 |
| Q3 | 40.76276 |
| 95-th percentile | 40.82669 |
| Maximum | 40.91697 |
| Range | 0.41718 |
| Interquartile range (IQR) | 0.07402 |
Descriptive statistics
| Standard deviation | 0.05589175 |
|---|---|
| Coefficient of variation (CV) | 0.0013723151 |
| Kurtosis | 0.1501276 |
| Mean | 40.728072 |
| Median Absolute Deviation (MAD) | 0.03673 |
| Skewness | 0.22915667 |
| Sum | 4262233.5 |
| Variance | 0.0031238877 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40.76411 | 36 | < 0.1% |
| 40.71813 | 32 | < 0.1% |
| 40.76125 | 29 | < 0.1% |
| 40.73756 | 28 | < 0.1% |
| 40.71353 | 26 | < 0.1% |
| 40.76106 | 25 | < 0.1% |
| 40.7244 | 25 | < 0.1% |
| 40.6898 | 25 | < 0.1% |
| 40.68537 | 24 | < 0.1% |
| 40.70719 | 23 | < 0.1% |
| Other values (21982) | 104378 |
| Value | Count | Frequency (%) |
| 40.49979 | 1 | |
| 40.50456 | 1 | |
| 40.50641 | 1 | |
| 40.50708 | 2 | |
| 40.50863 | 2 | |
| 40.50868 | 2 | |
| 40.50873 | 2 | |
| 40.50943 | 1 | |
| 40.51133 | 2 | |
| 40.52211 | 2 |
| Value | Count | Frequency (%) |
| 40.91697 | 1 | |
| 40.91685 | 1 | |
| 40.9131 | 1 | |
| 40.91306 | 1 | |
| 40.91248 | 1 | |
| 40.91234 | 1 | |
| 40.91169 | 2 | |
| 40.91167 | 1 | |
| 40.9116 | 1 | |
| 40.91139 | 1 |
long
Real number (ℝ)
High correlation
| Distinct | 17774 |
|---|---|
| Distinct (%) | 17.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.949641 |
| Minimum | -74.24984 |
|---|---|
| Maximum | -73.70522 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 104651 |
| Negative (%) | 100.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | -74.24984 |
|---|---|
| 5-th percentile | -74.00387 |
| Q1 | -73.98258 |
| median | -73.95445 |
| Q3 | -73.93234 |
| 95-th percentile | -73.85112 |
| Maximum | -73.70522 |
| Range | 0.54462 |
| Interquartile range (IQR) | 0.05024 |
Descriptive statistics
| Standard deviation | 0.049534423 |
|---|---|
| Coefficient of variation (CV) | -0.00066983994 |
| Kurtosis | 4.3308443 |
| Mean | -73.949641 |
| Median Absolute Deviation (MAD) | 0.02596 |
| Skewness | 1.242063 |
| Sum | -7738903.9 |
| Variance | 0.0024536591 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -73.99371 | 44 | < 0.1% |
| -73.9535 | 41 | < 0.1% |
| -73.94791 | 37 | < 0.1% |
| -73.95427 | 37 | < 0.1% |
| -73.94977 | 35 | < 0.1% |
| -73.95677 | 34 | < 0.1% |
| -73.95675 | 33 | < 0.1% |
| -73.94513 | 33 | < 0.1% |
| -73.943 | 32 | < 0.1% |
| -73.95732 | 32 | < 0.1% |
| Other values (17764) | 104293 |
| Value | Count | Frequency (%) |
| -74.24984 | 1 | |
| -74.24442 | 1 | |
| -74.24285 | 2 | |
| -74.24135 | 2 | |
| -74.24084 | 1 | |
| -74.23986 | 2 | |
| -74.23914 | 2 | |
| -74.23803 | 2 | |
| -74.23059 | 1 | |
| -74.21238 | 1 |
| Value | Count | Frequency (%) |
| -73.70522 | 1 | < 0.1% |
| -73.70524 | 1 | < 0.1% |
| -73.71087 | 1 | < 0.1% |
| -73.71299 | 3 | |
| -73.7169 | 1 | < 0.1% |
| -73.71795 | 1 | < 0.1% |
| -73.71829 | 1 | < 0.1% |
| -73.71928 | 1 | < 0.1% |
| -73.71997 | 1 | < 0.1% |
| -73.72122 | 1 | < 0.1% |
country
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.2 MiB |
| UNITED STATES |
|---|
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | UNITED STATES |
|---|---|
| 2nd row | UNITED STATES |
| 3rd row | UNITED STATES |
| 4th row | UNITED STATES |
| 5th row | UNITED STATES |
Common Values
| Value | Count | Frequency (%) |
| UNITED STATES | 104651 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 104651 | |
| states | 104651 |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 313953 | |
| S | 209302 | |
| E | 209302 | |
| U | 104651 | 7.7% |
| I | 104651 | 7.7% |
| N | 104651 | 7.7% |
| D | 104651 | 7.7% |
| 104651 | 7.7% | |
| A | 104651 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1360463 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| T | 313953 | |
| S | 209302 | |
| E | 209302 | |
| U | 104651 | 7.7% |
| I | 104651 | 7.7% |
| N | 104651 | 7.7% |
| D | 104651 | 7.7% |
| 104651 | 7.7% | |
| A | 104651 | 7.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1360463 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| T | 313953 | |
| S | 209302 | |
| E | 209302 | |
| U | 104651 | 7.7% |
| I | 104651 | 7.7% |
| N | 104651 | 7.7% |
| D | 104651 | 7.7% |
| 104651 | 7.7% | |
| A | 104651 | 7.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1360463 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| T | 313953 | |
| S | 209302 | |
| E | 209302 | |
| U | 104651 | 7.7% |
| I | 104651 | 7.7% |
| N | 104651 | 7.7% |
| D | 104651 | 7.7% |
| 104651 | 7.7% | |
| A | 104651 | 7.7% |
country code
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.1 MiB |
| US |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
Common Values
| Value | Count | Frequency (%) |
| US | 104651 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| us | 104651 |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 104651 | |
| S | 104651 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 209302 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 104651 | |
| S | 104651 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 209302 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 104651 | |
| S | 104651 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 209302 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 104651 | |
| S | 104651 |
instant_bookable
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 102.3 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 52620 | |
| True | 52031 |
cancellation_policy
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 MiB |
| MODERATE | |
|---|---|
| STRICT | |
| FLEXIBLE |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.3350661 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FLEXIBLE |
|---|---|
| 2nd row | MODERATE |
| 3rd row | FLEXIBLE |
| 4th row | MODERATE |
| 5th row | FLEXIBLE |
Common Values
| Value | Count | Frequency (%) |
| MODERATE | 35109 | |
| STRICT | 34793 | |
| FLEXIBLE | 34749 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| moderate | 35109 | |
| strict | 34793 | |
| flexible | 34749 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 139716 | |
| T | 104695 | |
| R | 69902 | |
| I | 69542 | |
| L | 69498 | |
| O | 35109 | 4.6% |
| A | 35109 | 4.6% |
| D | 35109 | 4.6% |
| M | 35109 | 4.6% |
| S | 34793 | 4.5% |
| Other values (4) | 139040 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 767622 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 139716 | |
| T | 104695 | |
| R | 69902 | |
| I | 69542 | |
| L | 69498 | |
| O | 35109 | 4.6% |
| A | 35109 | 4.6% |
| D | 35109 | 4.6% |
| M | 35109 | 4.6% |
| S | 34793 | 4.5% |
| Other values (4) | 139040 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 767622 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 139716 | |
| T | 104695 | |
| R | 69902 | |
| I | 69542 | |
| L | 69498 | |
| O | 35109 | 4.6% |
| A | 35109 | 4.6% |
| D | 35109 | 4.6% |
| M | 35109 | 4.6% |
| S | 34793 | 4.5% |
| Other values (4) | 139040 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 767622 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 139716 | |
| T | 104695 | |
| R | 69902 | |
| I | 69542 | |
| L | 69498 | |
| O | 35109 | 4.6% |
| A | 35109 | 4.6% |
| D | 35109 | 4.6% |
| M | 35109 | 4.6% |
| S | 34793 | 4.5% |
| Other values (4) | 139040 |
room type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.2 MiB |
| ENTIRE HOME/APT | |
|---|---|
| PRIVATE ROOM | |
| SHARED ROOM | 2263 |
| HOTEL ROOM | 120 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.546101 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ENTIRE HOME/APT |
|---|---|
| 2nd row | PRIVATE ROOM |
| 3rd row | ENTIRE HOME/APT |
| 4th row | ENTIRE HOME/APT |
| 5th row | ENTIRE HOME/APT |
Common Values
| Value | Count | Frequency (%) |
| ENTIRE HOME/APT | 54768 | |
| PRIVATE ROOM | 47500 | |
| SHARED ROOM | 2263 | 2.2% |
| HOTEL ROOM | 120 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| entire | 54768 | |
| home/apt | 54768 | |
| room | 49883 | |
| private | 47500 | |
| shared | 2263 | 1.1% |
| hotel | 120 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 214187 | |
| T | 157156 | |
| O | 154654 | |
| R | 154414 | |
| 104651 | ||
| M | 104651 | |
| A | 104531 | |
| I | 102268 | |
| P | 102268 | |
| H | 57151 | 4.0% |
| Other values (6) | 161682 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1417613 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 214187 | |
| T | 157156 | |
| O | 154654 | |
| R | 154414 | |
| 104651 | ||
| M | 104651 | |
| A | 104531 | |
| I | 102268 | |
| P | 102268 | |
| H | 57151 | 4.0% |
| Other values (6) | 161682 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1417613 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 214187 | |
| T | 157156 | |
| O | 154654 | |
| R | 154414 | |
| 104651 | ||
| M | 104651 | |
| A | 104531 | |
| I | 102268 | |
| P | 102268 | |
| H | 57151 | 4.0% |
| Other values (6) | 161682 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1417613 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 214187 | |
| T | 157156 | |
| O | 154654 | |
| R | 154414 | |
| 104651 | ||
| M | 104651 | |
| A | 104531 | |
| I | 102268 | |
| P | 102268 | |
| H | 57151 | 4.0% |
| Other values (6) | 161682 |
Construction year
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2012.4837 |
| Minimum | 2003 |
|---|---|
| Maximum | 2022 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | 2003 |
|---|---|
| 5-th percentile | 2003 |
| Q1 | 2008 |
| median | 2012 |
| Q3 | 2017 |
| 95-th percentile | 2022 |
| Maximum | 2022 |
| Range | 19 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 5.7605996 |
|---|---|
| Coefficient of variation (CV) | 0.0028624329 |
| Kurtosis | -1.2036511 |
| Mean | 2012.4837 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.0066388104 |
| Sum | 2.1060843 × 108 |
| Variance | 33.184508 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 2014 | 5339 | 5.1% |
| 2006 | 5336 | 5.1% |
| 2008 | 5327 | 5.1% |
| 2019 | 5308 | 5.1% |
| 2009 | 5279 | 5.0% |
| 2010 | 5257 | 5.0% |
| 2020 | 5247 | 5.0% |
| 2012 | 5242 | 5.0% |
| 2022 | 5239 | 5.0% |
| 2005 | 5236 | 5.0% |
| Other values (11) | 51841 |
| Value | Count | Frequency (%) |
| 2003 | 5234 | |
| 2004 | 5154 | |
| 2005 | 5236 | |
| 2006 | 5336 | |
| 2007 | 5200 | |
| 2008 | 5327 | |
| 2009 | 5279 | |
| 2010 | 5257 | |
| 2011 | 5160 | |
| 2012 | 5242 |
| Value | Count | Frequency (%) |
| 2022 | 5239 | |
| 2021 | 5141 | |
| 2020 | 5247 | |
| 2019 | 5308 | |
| 2018 | 5151 | |
| 2017 | 5171 | |
| 2016 | 5102 | |
| 2015 | 5195 | |
| 2014 | 5339 | |
| 2013 | 5116 |
minimum nights
Real number (ℝ)
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.8433364 |
| Minimum | -2.5 |
|---|---|
| Maximum | 9.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 13 |
| Negative (%) | < 0.1% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | -2.5 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 9.5 |
| Maximum | 9.5 |
| Range | 12 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 3.0430876 |
|---|---|
| Coefficient of variation (CV) | 0.79178278 |
| Kurtosis | -0.56725282 |
| Mean | 3.8433364 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.9584989 |
| Sum | 402209 |
| Variance | 9.2603822 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| 1 | 25941 | |
| 2 | 24082 | |
| 9.5 | 18739 | |
| 3 | 16877 | |
| 4 | 6728 | 6.4% |
| 5 | 6165 | 5.9% |
| 7 | 4122 | 3.9% |
| 6 | 1571 | 1.5% |
| 8 | 251 | 0.2% |
| 9 | 162 | 0.2% |
| Other values (3) | 13 | < 0.1% |
| Value | Count | Frequency (%) |
| -2.5 | 11 | < 0.1% |
| -2 | 1 | < 0.1% |
| -1 | 1 | < 0.1% |
| 1 | 25941 | |
| 2 | 24082 | |
| 3 | 16877 | |
| 4 | 6728 | 6.4% |
| 5 | 6165 | 5.9% |
| 6 | 1571 | 1.5% |
| 7 | 4122 | 3.9% |
| Value | Count | Frequency (%) |
| 9.5 | 18739 | |
| 9 | 162 | 0.2% |
| 8 | 251 | 0.2% |
| 7 | 4122 | 3.9% |
| 6 | 1571 | 1.5% |
| 5 | 6165 | 5.9% |
| 4 | 6728 | 6.4% |
| 3 | 16877 | |
| 2 | 24082 | |
| 1 | 25941 |
number of reviews
Real number (ℝ)
High correlation Zeros
| Distinct | 476 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.441343 |
| Minimum | 0 |
|---|---|
| Maximum | 1024 |
| Zeros | 16045 |
| Zeros (%) | 15.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 7 |
| Q3 | 30 |
| 95-th percentile | 125 |
| Maximum | 1024 |
| Range | 1024 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 49.391322 |
|---|---|
| Coefficient of variation (CV) | 1.7998872 |
| Kurtosis | 24.893079 |
| Mean | 27.441343 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 3.8299982 |
| Sum | 2871764 |
| Variance | 2439.5027 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 16045 | 15.3% |
| 1 | 10600 | 10.1% |
| 2 | 7318 | 7.0% |
| 3 | 5481 | 5.2% |
| 4 | 4236 | 4.0% |
| 5 | 3494 | 3.3% |
| 6 | 2986 | 2.9% |
| 7 | 2766 | 2.6% |
| 8 | 2413 | 2.3% |
| 9 | 2152 | 2.1% |
| Other values (466) | 47160 |
| Value | Count | Frequency (%) |
| 0 | 16045 | |
| 1 | 10600 | |
| 2 | 7318 | |
| 3 | 5481 | 5.2% |
| 4 | 4236 | 4.0% |
| 5 | 3494 | 3.3% |
| 6 | 2986 | 2.9% |
| 7 | 2766 | 2.6% |
| 8 | 2413 | 2.3% |
| 9 | 2152 | 2.1% |
| Value | Count | Frequency (%) |
| 1024 | 1 | |
| 1010 | 1 | |
| 966 | 1 | |
| 884 | 1 | |
| 849 | 1 | |
| 797 | 1 | |
| 776 | 1 | |
| 738 | 1 | |
| 698 | 1 | |
| 679 | 1 |
reviews per month
Real number (ℝ)
High correlation
| Distinct | 1016 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2766491 |
| Minimum | 0.01 |
|---|---|
| Maximum | 90 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.05 |
| Q1 | 0.28 |
| median | 0.74 |
| Q3 | 1.71 |
| 95-th percentile | 4.32 |
| Maximum | 90 |
| Range | 89.99 |
| Interquartile range (IQR) | 1.43 |
Descriptive statistics
| Standard deviation | 1.621826 |
|---|---|
| Coefficient of variation (CV) | 1.2703773 |
| Kurtosis | 244.2229 |
| Mean | 1.2766491 |
| Median Absolute Deviation (MAD) | 0.55 |
| Skewness | 7.5021525 |
| Sum | 133602.6 |
| Variance | 2.6303194 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.74 | 16421 | 15.7% |
| 0.03 | 1694 | 1.6% |
| 0.05 | 1522 | 1.5% |
| 1 | 1486 | 1.4% |
| 0.09 | 1296 | 1.2% |
| 0.04 | 1296 | 1.2% |
| 0.16 | 1282 | 1.2% |
| 0.08 | 1279 | 1.2% |
| 0.06 | 1221 | 1.2% |
| 0.02 | 1181 | 1.1% |
| Other values (1006) | 75973 |
| Value | Count | Frequency (%) |
| 0.01 | 67 | 0.1% |
| 0.02 | 1181 | |
| 0.03 | 1694 | |
| 0.04 | 1296 | |
| 0.05 | 1522 | |
| 0.06 | 1221 | |
| 0.07 | 1102 | |
| 0.08 | 1279 | |
| 0.09 | 1296 | |
| 0.1 | 1009 |
| Value | Count | Frequency (%) |
| 90 | 1 | |
| 84.49 | 1 | |
| 65.74 | 1 | |
| 58.5 | 2 | |
| 57.31 | 1 | |
| 47.11 | 1 | |
| 44.63 | 1 | |
| 34.46 | 1 | |
| 33.08 | 1 | |
| 30.51 | 1 |
review rate number
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.2797024 |
| Minimum | 1 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.2829167 |
|---|---|
| Coefficient of variation (CV) | 0.39116862 |
| Kurtosis | -1.1213596 |
| Mean | 3.2797024 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.13952912 |
| Sum | 343224.14 |
| Variance | 1.6458752 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 5 | 23865 | |
| 4 | 23797 | |
| 3 | 23705 | |
| 2 | 23553 | |
| 1 | 9398 | 9.0% |
| 3.279702448 | 333 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 9398 | 9.0% |
| 2 | 23553 | |
| 3 | 23705 | |
| 3.279702448 | 333 | 0.3% |
| 4 | 23797 | |
| 5 | 23865 |
| Value | Count | Frequency (%) |
| 5 | 23865 | |
| 4 | 23797 | |
| 3.279702448 | 333 | 0.3% |
| 3 | 23705 | |
| 2 | 23553 | |
| 1 | 9398 | 9.0% |
calculated host listings count
Real number (ℝ)
| Distinct | 78 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.9226668 |
| Minimum | 1 |
|---|---|
| Maximum | 332 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 28.5 |
| Maximum | 332 |
| Range | 331 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 32.216562 |
|---|---|
| Coefficient of variation (CV) | 4.0663786 |
| Kurtosis | 58.833937 |
| Mean | 7.9226668 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.2313897 |
| Sum | 829115 |
| Variance | 1037.9069 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 65024 | |
| 2 | 14715 | 14.1% |
| 3 | 6715 | 6.4% |
| 4 | 3637 | 3.5% |
| 5 | 2037 | 1.9% |
| 6 | 1506 | 1.4% |
| 7 | 1011 | 1.0% |
| 8 | 975 | 0.9% |
| 9 | 559 | 0.5% |
| 10 | 523 | 0.5% |
| Other values (68) | 7949 | 7.6% |
| Value | Count | Frequency (%) |
| 1 | 65024 | |
| 2 | 14715 | 14.1% |
| 3 | 6715 | 6.4% |
| 4 | 3637 | 3.5% |
| 5 | 2037 | 1.9% |
| 6 | 1506 | 1.4% |
| 7 | 1011 | 1.0% |
| 8 | 975 | 0.9% |
| 9 | 559 | 0.5% |
| 10 | 523 | 0.5% |
| Value | Count | Frequency (%) |
| 332 | 41 | < 0.1% |
| 327 | 483 | |
| 232 | 274 | |
| 218 | 30 | < 0.1% |
| 208 | 211 | |
| 186 | 154 | 0.1% |
| 171 | 66 | 0.1% |
| 161 | 117 | 0.1% |
| 152 | 57 | 0.1% |
| 126 | 55 | 0.1% |
availability 365
Real number (ℝ)
Zeros
| Distinct | 438 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 141.03003 |
| Minimum | -10 |
|---|---|
| Maximum | 3677 |
| Zeros | 24007 |
| Zeros (%) | 22.9% |
| Negative | 438 |
| Negative (%) | 0.4% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | -10 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 97 |
| Q3 | 268 |
| 95-th percentile | 365 |
| Maximum | 3677 |
| Range | 3687 |
| Interquartile range (IQR) | 265 |
Descriptive statistics
| Standard deviation | 135.18523 |
|---|---|
| Coefficient of variation (CV) | 0.95855632 |
| Kurtosis | 3.1917403 |
| Mean | 141.03003 |
| Median Absolute Deviation (MAD) | 97 |
| Skewness | 0.64390263 |
| Sum | 14758934 |
| Variance | 18275.046 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 24007 | 22.9% |
| 365 | 2553 | 2.4% |
| 364 | 1187 | 1.1% |
| 89 | 771 | 0.7% |
| 1 | 745 | 0.7% |
| 179 | 698 | 0.7% |
| 90 | 687 | 0.7% |
| 5 | 639 | 0.6% |
| 97 | 594 | 0.6% |
| 3 | 592 | 0.6% |
| Other values (428) | 72178 |
| Value | Count | Frequency (%) |
| -10 | 38 | |
| -9 | 48 | |
| -8 | 50 | |
| -7 | 37 | |
| -6 | 32 | |
| -5 | 59 | |
| -4 | 42 | |
| -3 | 43 | |
| -2 | 43 | |
| -1 | 46 |
| Value | Count | Frequency (%) |
| 3677 | 1 | < 0.1% |
| 426 | 47 | |
| 425 | 51 | |
| 424 | 38 | |
| 423 | 49 | |
| 422 | 48 | |
| 421 | 43 | |
| 420 | 41 | |
| 419 | 45 | |
| 418 | 49 |
price_clean
Real number (ℝ)
High correlation
| Distinct | 1152 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 625.31834 |
| Minimum | 50 |
|---|---|
| Maximum | 1200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 108 |
| Q1 | 340.5 |
| median | 625.31834 |
| Q3 | 912 |
| 95-th percentile | 1143 |
| Maximum | 1200 |
| Range | 1150 |
| Interquartile range (IQR) | 571.5 |
Descriptive statistics
| Standard deviation | 331.20697 |
|---|---|
| Coefficient of variation (CV) | 0.52966138 |
| Kurtosis | -1.1897256 |
| Mean | 625.31834 |
| Median Absolute Deviation (MAD) | 285.68166 |
| Skewness | 0.0010186731 |
| Sum | 65440190 |
| Variance | 109698.06 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 625.3183425 | 254 | 0.2% |
| 206 | 141 | 0.1% |
| 1056 | 137 | 0.1% |
| 481 | 130 | 0.1% |
| 833 | 129 | 0.1% |
| 573 | 128 | 0.1% |
| 972 | 128 | 0.1% |
| 138 | 124 | 0.1% |
| 430 | 122 | 0.1% |
| 406 | 122 | 0.1% |
| Other values (1142) | 103236 |
| Value | Count | Frequency (%) |
| 50 | 95 | |
| 51 | 88 | |
| 52 | 90 | |
| 53 | 66 | |
| 54 | 68 | |
| 55 | 100 | |
| 56 | 109 | |
| 57 | 88 | |
| 58 | 83 | |
| 59 | 112 |
| Value | Count | Frequency (%) |
| 1200 | 71 | |
| 1199 | 102 | |
| 1198 | 80 | |
| 1197 | 80 | |
| 1196 | 79 | |
| 1195 | 95 | |
| 1194 | 77 | |
| 1193 | 74 | |
| 1192 | 72 | |
| 1191 | 92 |
last review_date
Date
Missing
| Distinct | 2477 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 16206 |
| Missing (%) | 15.5% |
| Memory size | 817.7 KiB |
| Minimum | 2012-07-11 00:00:00 |
|---|---|
| Maximum | 2058-06-16 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
service fee_cleaned
Real number (ℝ)
High correlation
| Distinct | 232 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 125.03086 |
| Minimum | 10 |
|---|---|
| Maximum | 240 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 817.7 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 68 |
| median | 125 |
| Q3 | 182 |
| 95-th percentile | 229 |
| Maximum | 240 |
| Range | 230 |
| Interquartile range (IQR) | 114 |
Descriptive statistics
| Standard deviation | 66.225902 |
|---|---|
| Coefficient of variation (CV) | 0.52967645 |
| Kurtosis | -1.1887984 |
| Mean | 125.03086 |
| Median Absolute Deviation (MAD) | 57 |
| Skewness | 0.0016650957 |
| Sum | 13084605 |
| Variance | 4385.87 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 41 | 543 | 0.5% |
| 216 | 537 | 0.5% |
| 81 | 531 | 0.5% |
| 177 | 531 | 0.5% |
| 57 | 520 | 0.5% |
| 207 | 515 | 0.5% |
| 128 | 512 | 0.5% |
| 127 | 511 | 0.5% |
| 178 | 508 | 0.5% |
| 92 | 506 | 0.5% |
| Other values (222) | 99437 |
| Value | Count | Frequency (%) |
| 10 | 273 | |
| 11 | 431 | |
| 12 | 441 | |
| 13 | 439 | |
| 14 | 454 | |
| 15 | 461 | |
| 16 | 502 | |
| 17 | 422 | |
| 18 | 432 | |
| 19 | 442 |
| Value | Count | Frequency (%) |
| 240 | 253 | |
| 239 | 405 | |
| 238 | 467 | |
| 237 | 479 | |
| 236 | 430 | |
| 235 | 448 | |
| 234 | 473 | |
| 233 | 446 | |
| 232 | 428 | |
| 231 | 468 |
Interactions
Correlations
| Construction year | availability 365 | calculated host listings count | cancellation_policy | host id | host_identity_verified | id | instant_bookable | lat | long | minimum nights | neighbourhood group | number of reviews | price_clean | review rate number | reviews per month | room type | service fee_cleaned | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Construction year | 1.000 | -0.006 | -0.005 | 0.003 | 0.005 | 0.000 | 0.001 | 0.000 | 0.004 | 0.001 | -0.003 | 0.009 | 0.002 | -0.005 | 0.005 | 0.003 | 0.005 | -0.004 |
| availability 365 | -0.006 | 1.000 | 0.296 | 0.000 | -0.003 | 0.003 | -0.155 | 0.000 | -0.001 | 0.037 | 0.030 | 0.032 | 0.136 | -0.003 | -0.003 | 0.153 | 0.046 | -0.003 |
| calculated host listings count | -0.005 | 0.296 | 1.000 | 0.003 | 0.003 | 0.000 | 0.058 | 0.000 | 0.025 | 0.047 | 0.064 | 0.088 | 0.053 | 0.001 | 0.035 | 0.092 | 0.077 | 0.002 |
| cancellation_policy | 0.003 | 0.000 | 0.003 | 1.000 | 0.000 | 0.000 | 0.000 | 0.007 | 0.004 | 0.000 | 0.000 | 0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| host id | 0.005 | -0.003 | 0.003 | 0.000 | 1.000 | 0.007 | -0.001 | 0.000 | 0.001 | -0.009 | -0.000 | 0.004 | -0.006 | 0.003 | 0.003 | -0.004 | 0.006 | 0.003 |
| host_identity_verified | 0.000 | 0.003 | 0.000 | 0.000 | 0.007 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.007 | 0.000 | 0.008 | 0.000 | 0.000 | 0.000 |
| id | 0.001 | -0.155 | 0.058 | 0.000 | -0.001 | 0.000 | 1.000 | 0.003 | -0.009 | 0.040 | 0.019 | 0.048 | 0.008 | 0.007 | 0.033 | 0.056 | 0.066 | 0.007 |
| instant_bookable | 0.000 | 0.000 | 0.000 | 0.007 | 0.000 | 0.000 | 0.003 | 1.000 | 0.005 | 0.005 | 0.004 | 0.000 | 0.000 | 0.008 | 0.000 | 0.000 | 0.000 | 0.005 |
| lat | 0.004 | -0.001 | 0.025 | 0.004 | 0.001 | 0.000 | -0.009 | 0.005 | 1.000 | 0.033 | 0.030 | 0.440 | -0.052 | -0.006 | -0.003 | -0.037 | 0.089 | -0.006 |
| long | 0.001 | 0.037 | 0.047 | 0.000 | -0.009 | 0.000 | 0.040 | 0.005 | 0.033 | 1.000 | -0.110 | 0.538 | 0.091 | 0.004 | 0.011 | 0.109 | 0.119 | 0.004 |
| minimum nights | -0.003 | 0.030 | 0.064 | 0.000 | -0.000 | 0.000 | 0.019 | 0.004 | 0.030 | -0.110 | 1.000 | 0.067 | -0.170 | -0.004 | 0.003 | -0.294 | 0.144 | -0.004 |
| neighbourhood group | 0.009 | 0.032 | 0.088 | 0.003 | 0.004 | 0.000 | 0.048 | 0.000 | 0.440 | 0.538 | 0.067 | 1.000 | 0.023 | 0.007 | 0.017 | 0.027 | 0.094 | 0.006 |
| number of reviews | 0.002 | 0.136 | 0.053 | 0.000 | -0.006 | 0.007 | 0.008 | 0.000 | -0.052 | 0.091 | -0.170 | 0.023 | 1.000 | 0.005 | -0.013 | 0.570 | 0.064 | 0.005 |
| price_clean | -0.005 | -0.003 | 0.001 | 0.000 | 0.003 | 0.000 | 0.007 | 0.008 | -0.006 | 0.004 | -0.004 | 0.007 | 0.005 | 1.000 | -0.005 | 0.003 | 0.011 | 0.998 |
| review rate number | 0.005 | -0.003 | 0.035 | 0.000 | 0.003 | 0.008 | 0.033 | 0.000 | -0.003 | 0.011 | 0.003 | 0.017 | -0.013 | -0.005 | 1.000 | 0.045 | 0.008 | -0.005 |
| reviews per month | 0.003 | 0.153 | 0.092 | 0.000 | -0.004 | 0.000 | 0.056 | 0.000 | -0.037 | 0.109 | -0.294 | 0.027 | 0.570 | 0.003 | 0.045 | 1.000 | 0.084 | 0.003 |
| room type | 0.005 | 0.046 | 0.077 | 0.000 | 0.006 | 0.000 | 0.066 | 0.000 | 0.089 | 0.119 | 0.144 | 0.094 | 0.064 | 0.011 | 0.008 | 0.084 | 1.000 | 0.010 |
| service fee_cleaned | -0.004 | -0.003 | 0.002 | 0.000 | 0.003 | 0.000 | 0.007 | 0.005 | -0.006 | 0.004 | -0.004 | 0.006 | 0.005 | 0.998 | -0.005 | 0.003 | 0.010 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| id | NAME | host id | host_identity_verified | host name | neighbourhood group | neighbourhood | lat | long | country | country code | instant_bookable | cancellation_policy | room type | Construction year | minimum nights | number of reviews | reviews per month | review rate number | calculated host listings count | availability 365 | price_clean | last review_date | service fee_cleaned | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 14742560 | CLASSIC ARTIST LOFT | 97210996539 | VERIFIED | JOSH | BROOKLYN | COLUMBIA ST | 40.68626 | -74.00141 | UNITED STATES | US | True | FLEXIBLE | ENTIRE HOME/APT | 2013.0 | 4.0 | 9.0 | 0.38 | 5.0 | 1.0 | 74.0 | 616.0 | 2019-06-26 | 123.0 |
| 1 | 55508928 | ÉTAGE AU SEIN D’UN DUPLEX À BROOKLYN | 33249221187 | UNCONFIRMED | SOPHIE & GRÉGOIRE | BROOKLYN | CLINTON HILL | 40.68227 | -73.96486 | UNITED STATES | US | True | MODERATE | PRIVATE ROOM | 2005.0 | 2.0 | 9.0 | 0.89 | 2.0 | 1.0 | 17.0 | 1095.0 | 2019-06-30 | 219.0 |
| 2 | 30561537 | AMAZING VIEW IN ULTRA LUXURY MIDTOWN APARTMENT! | 63109258528 | VERIFIED | MAY | MANHATTAN | HELL'S KITCHEN | 40.75275 | -73.99330 | UNITED STATES | US | False | FLEXIBLE | ENTIRE HOME/APT | 2015.0 | 1.0 | 28.0 | 3.64 | 4.0 | 6.0 | 334.0 | 969.0 | 2022-02-17 | 194.0 |
| 3 | 13914662 | HARLEM HOME AWAY FROM HOME! | 42768739399 | VERIFIED | ARIELLE | MANHATTAN | HARLEM | 40.82843 | -73.94672 | UNITED STATES | US | True | MODERATE | ENTIRE HOME/APT | 2021.0 | 3.0 | 4.0 | 0.16 | 1.0 | 1.0 | 0.0 | 778.0 | 2019-06-25 | 156.0 |
| 4 | 9063811 | COZY LOFT IN FLUSHING | 41428819097 | VERIFIED | ERJON | QUEENS | FLUSHING | 40.75485 | -73.82138 | UNITED STATES | US | False | FLEXIBLE | ENTIRE HOME/APT | 2009.0 | 3.0 | 1.0 | 0.02 | 1.0 | 1.0 | 368.0 | 815.0 | 2016-03-25 | 163.0 |
| 5 | 22883462 | REAL BROOKLYN APT ON PACIFIC AND NEW YORK | 1508400733 | UNCONFIRMED | MATT | BROOKLYN | CROWN HEIGHTS | 40.67683 | -73.94702 | UNITED STATES | US | False | MODERATE | PRIVATE ROOM | 2007.0 | 5.0 | 2.0 | 0.32 | 4.0 | 1.0 | 220.0 | 172.0 | 2019-02-01 | 34.0 |
| 6 | 38229670 | PRIME, SPACIOUS WEST VILLAGE APARTMENT | 22981236558 | VERIFIED | JORDAN | MANHATTAN | GREENWICH VILLAGE | 40.73129 | -74.00097 | UNITED STATES | US | True | FLEXIBLE | PRIVATE ROOM | 2017.0 | 9.5 | 61.0 | 1.95 | 4.0 | 1.0 | 0.0 | 1181.0 | 2020-04-05 | 236.0 |
| 7 | 26509864 | PRIVATE, NEWLY RENOVATED BEDROOM, 10 MINS FROM JFK | 82159107182 | UNCONFIRMED | MINA | QUEENS | HOWARD BEACH | 40.66635 | -73.85258 | UNITED STATES | US | True | STRICT | PRIVATE ROOM | 2003.0 | 1.0 | 3.0 | 2.14 | 2.0 | 4.0 | 329.0 | 320.0 | 2019-07-06 | 64.0 |
| 8 | 55141648 | BRIGHT WILLIAMSBURG ROOM WITH HUGE PRIVATE TERRACE | 40990182521 | UNCONFIRMED | BEN | BROOKLYN | WILLIAMSBURG | 40.71247 | -73.94548 | UNITED STATES | US | True | STRICT | PRIVATE ROOM | 2003.0 | 1.0 | 2.0 | 0.18 | 5.0 | 1.0 | 0.0 | 986.0 | 2018-09-05 | 197.0 |
| 9 | 9103577 | CHARMING PREWAR UPPER WEST SIDE APT | 87433243922 | VERIFIED | DANIEL | MANHATTAN | UPPER WEST SIDE | 40.79828 | -73.97166 | UNITED STATES | US | False | FLEXIBLE | ENTIRE HOME/APT | 2013.0 | 1.0 | 0.0 | 0.74 | 1.0 | 1.0 | 95.0 | 714.0 | NaN | 143.0 |
| id | NAME | host id | host_identity_verified | host name | neighbourhood group | neighbourhood | lat | long | country | country code | instant_bookable | cancellation_policy | room type | Construction year | minimum nights | number of reviews | reviews per month | review rate number | calculated host listings count | availability 365 | price_clean | last review_date | service fee_cleaned | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104641 | 25374887 | BIG ROOM PRIME LOCATION WAHE UPTOWN MANHATTAN | 48898220621 | VERIFIED | MAJSAN | MANHATTAN | WASHINGTON HEIGHTS | 40.84387 | -73.93969 | UNITED STATES | US | True | STRICT | PRIVATE ROOM | 2006.0 | 1.0 | 3.0 | 1.64 | 3.000000 | 1.0 | 293.0 | 1040.0 | 2019-06-11 | 208.0 |
| 104642 | 49326481 | LUXURY ROOM (RM3), 5 MINS FROM COLUMBIA | 49177551774 | VERIFIED | EUGENE | MANHATTAN | MORNINGSIDE HEIGHTS | 40.81097 | -73.96001 | UNITED STATES | US | False | MODERATE | PRIVATE ROOM | 2020.0 | 3.0 | 68.0 | 1.88 | 5.000000 | 6.0 | 128.0 | 167.0 | 2019-06-24 | 33.0 |
| 104643 | 21543582 | NIGHTS IN MIDTOWN MANHATTAN-LADIES ONLY | 510689754 | UNCONFIRMED | MELANIE | MANHATTAN | KIPS BAY | 40.74579 | -73.97887 | UNITED STATES | US | False | FLEXIBLE | SHARED ROOM | 2007.0 | 2.0 | 6.0 | 0.74 | 2.000000 | 3.0 | 352.0 | 221.0 | 2019-04-21 | 44.0 |
| 104644 | 46503124 | GIGI'S STUNNING PLACE | 32899803868 | UNCONFIRMED | GLORIA | BROOKLYN | EAST NEW YORK | 40.67118 | -73.86821 | UNITED STATES | US | True | MODERATE | ENTIRE HOME/APT | 2016.0 | 1.0 | 42.0 | 1.79 | 5.000000 | 1.0 | 348.0 | 1077.0 | 2019-06-30 | 215.0 |
| 104645 | 4461496 | ZEN DEN & MODERN OUTDOOR SPACE | 10269939573 | UNCONFIRMED | CARMEN | BROOKLYN | CYPRESS HILLS | 40.68711 | -73.87336 | UNITED STATES | US | True | FLEXIBLE | ENTIRE HOME/APT | 2010.0 | 3.0 | 114.0 | 2.02 | 3.000000 | 1.0 | 217.0 | 768.0 | 2019-06-24 | 154.0 |
| 104646 | 31314874 | AWESOME PRIVATE ROOM WITH WIFI & SELF CHECK-IN | 47647391192 | VERIFIED | CAROL | BROOKLYN | PROSPECT-LEFFERTS GARDENS | 40.66028 | -73.94217 | UNITED STATES | US | False | STRICT | PRIVATE ROOM | 2021.0 | 1.0 | 14.0 | 4.00 | 3.000000 | 17.0 | 179.0 | 1065.0 | 2022-02-11 | 213.0 |
| 104647 | 43429022 | SERENITY NEAR TIME SQUARE | 8913095036 | UNCONFIRMED | ROSHELLE | MANHATTAN | HELL'S KITCHEN | 40.75764 | -73.98963 | UNITED STATES | US | False | FLEXIBLE | PRIVATE ROOM | 2013.0 | 2.0 | 0.0 | 0.74 | 5.000000 | 1.0 | 0.0 | 174.0 | NaN | 35.0 |
| 104648 | 38167812 | ⚡STYLISH APT IN TRENDY LOCATION!! ⭐ | 85414163687 | UNCONFIRMED | SITO | MANHATTAN | CHELSEA | 40.73895 | -73.99837 | UNITED STATES | US | True | FLEXIBLE | ENTIRE HOME/APT | 2016.0 | 9.5 | 47.0 | 1.38 | 4.000000 | 1.0 | 0.0 | 450.0 | 2020-05-28 | 90.0 |
| 104649 | 1476314 | FULLY FURNISHED 1B/1BTH UWS GEM 1 YR SUBLEASE | 44588815342 | VERIFIED | STEWART | MANHATTAN | UPPER WEST SIDE | 40.78012 | -73.98439 | UNITED STATES | US | True | MODERATE | ENTIRE HOME/APT | 2007.0 | 1.0 | 0.0 | 0.74 | 3.279702 | 1.0 | 302.0 | 316.0 | NaN | 63.0 |
| 104650 | 9724915 | HAMILITON HEIGHTS HOME | 68074132275 | VERIFIED | LAUREN | MANHATTAN | HARLEM | 40.81934 | -73.95668 | UNITED STATES | US | True | STRICT | PRIVATE ROOM | 2017.0 | 2.0 | 0.0 | 0.74 | 4.000000 | 1.0 | 101.0 | 692.0 | NaN | 138.0 |
Duplicate rows
Most frequently occurring
| id | NAME | host id | host_identity_verified | host name | neighbourhood group | neighbourhood | lat | long | country | country code | instant_bookable | cancellation_policy | room type | Construction year | minimum nights | number of reviews | reviews per month | review rate number | calculated host listings count | availability 365 | price_clean | last review_date | service fee_cleaned | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 993 | 20387618 | SONDER | 116 JOHN | COZY 2BR+ GYM | 1165490779 | UNCONFIRMED | SONDER | MANHATTAN | FINANCIAL DISTRICT | 40.70797 | -74.00550 | UNITED STATES | US | False | MODERATE | ENTIRE HOME/APT | 2008.0 | 9.5 | 1.0 | 0.26 | 2.0 | 96.0 | 311.0 | 203.0 | 2019-03-16 | 41.0 | 4 |
| 230 | 6049910 | THE MOST EFFICIENT EFFICIENCY EVER | 45601026524 | UNCONFIRMED | GREG | BROOKLYN | WILLIAMSBURG | 40.70458 | -73.94095 | UNITED STATES | US | False | STRICT | ENTIRE HOME/APT | 2012.0 | 2.0 | 15.0 | 0.31 | 2.0 | 1.0 | 210.0 | 719.0 | 2019-07-01 | 144.0 | 3 |
| 295 | 6085810 | PRIVATE ROOM IN THE BEST PART OF BK | 4746552394 | VERIFIED | BRAD | BROOKLYN | CROWN HEIGHTS | 40.66743 | -73.94712 | UNITED STATES | US | False | FLEXIBLE | PRIVATE ROOM | 2011.0 | 7.0 | 49.0 | 1.01 | 2.0 | 1.0 | 425.0 | 516.0 | 2019-06-01 | 103.0 | 3 |
| 588 | 13970997 | SUNNY SPACIOUS 2 BEDROOM CONDO | 63177292896 | UNCONFIRMED | MICHELLE | BROOKLYN | CANARSIE | 40.62986 | -73.90638 | UNITED STATES | US | True | MODERATE | PRIVATE ROOM | 2012.0 | 2.0 | 45.0 | 1.78 | 4.0 | 1.0 | 41.0 | 658.0 | 2019-06-30 | 132.0 | 3 |
| 829 | 20297041 | FAM-FRIENDLY BROOKLYN BROWNSTONE W. VINTAGE CHARM | 1570276266 | UNCONFIRMED | ASHLEY | BROOKLYN | BEDFORD-STUYVESANT | 40.68398 | -73.93464 | UNITED STATES | US | True | MODERATE | ENTIRE HOME/APT | 2019.0 | 2.0 | 6.0 | 2.02 | 4.0 | 1.0 | 0.0 | 979.0 | 2019-06-27 | 196.0 | 3 |
| 841 | 20303669 | BROOKLYN PRIVATE APARTMENT | 27593217400 | VERIFIED | MARIA | BROOKLYN | BOROUGH PARK | 40.64480 | -73.99524 | UNITED STATES | US | True | MODERATE | ENTIRE HOME/APT | 2017.0 | 2.0 | 5.0 | 0.52 | 4.0 | 1.0 | 3.0 | 385.0 | 2019-01-04 | 77.0 | 3 |
| 849 | 20308087 | HARLEM GEM | 97528248465 | UNCONFIRMED | ERICA | MANHATTAN | EAST HARLEM | 40.80147 | -73.94432 | UNITED STATES | US | True | MODERATE | ENTIRE HOME/APT | 2020.0 | 3.0 | 2.0 | 0.19 | 3.0 | 1.0 | 0.0 | 813.0 | 2018-12-10 | 163.0 | 3 |
| 864 | 20316372 | PARK AVENUE HAVEN | 46677962999 | VERIFIED | ANNA | MANHATTAN | EAST HARLEM | 40.78954 | -73.95076 | UNITED STATES | US | False | FLEXIBLE | PRIVATE ROOM | 2004.0 | 1.0 | 35.0 | 3.90 | 4.0 | 1.0 | 90.0 | 362.0 | 2019-07-05 | 72.0 | 3 |
| 876 | 20322999 | WILLIAMSBURG LOFT - SPACIOUS, SKY-HIGH CEILINGS | 32108646910 | VERIFIED | JAY | BROOKLYN | WILLIAMSBURG | 40.71095 | -73.95171 | UNITED STATES | US | False | MODERATE | PRIVATE ROOM | 2005.0 | 9.5 | 0.0 | 0.74 | 5.0 | 2.0 | 157.0 | 946.0 | NaN | 189.0 | 3 |
| 907 | 20340121 | COZY CORNER NEAR EMPIRE STATE BUILDING | 40725508872 | VERIFIED | MARILUZ | MANHATTAN | MIDTOWN | 40.74858 | -73.98341 | UNITED STATES | US | True | MODERATE | SHARED ROOM | 2010.0 | 1.0 | 112.0 | 10.77 | 5.0 | 3.0 | 0.0 | 152.0 | 2019-06-13 | 30.0 | 3 |